﻿CREATE PROCEDURE [dbo].[FindAdjacentAirport]
	@AirportCode varchar(3)
AS
	SELECT Departure AS Airport
	FROM Segment
	WHERE Destination = @AirportCode
	UNION
	SELECT Destination AS Airport
	FROM Segment
	WHERE Departure = @AirportCode
RETURN 0